Copyright: People Index 1.0  Copyright Michael Cowan 1994


Contents

Copyright and registration

Overview

Presidents

Set Up

Install

Performance

Problems

Databases

Creating a new database

Selecting a database

Packing a database

Repairing a database

Noticeboard

Records

Adding records

Changing records

Deleting records

Copying and moving records

Jotter

Groups

A - Z Groups

Using Find

Searching Notes

Dates

Extracting data

Addresses

Listing records

Exporting records to spreadsheets

Dialling phone numbers


Copyright and registration

People Index is the copyright of Michael Cowan, 1994 and may be used only under licence obtainable from

Michael Cowan

Sparrow Information Systems

95 Allington Avenue

NOTTINGHAM NG7 1JY

United Kingdom

CIS 100343,3675

People Index may be used for a trial period of one month after which it must be registered with the copyright owner or deleted.

Registration removes the limit of 50 records per database and the registration notices.

Registration is US$30.   Payment covers the use of one copy in use on only one computer at any time on the 'use it like a book' principle.   Please specify your user name.

People Index (PNDX1) can be registered online with CompuServe:  GO SWREG.  You will receive a registration number via CIS mail.   If you wish to register a user name other than your normal CIS user name, send a message to Michael Cowan at 100343,3675 at the same time.

Alternatively, you may register by mail at the address above.   You will be sent a registration number by mail, or by fax or e-mail if you choose.   Please specify the user name you want and your return address,  and if needed your fax number and/or e-mail address.  Please pay by American Express payment order.   Personal checks are accepted subject to a delay for collection.

Registration for use by any business, public service or other organisation is on a per copy basis by agreement.   Please contact the author at the mail or e-mail address above.

When you receive your registration number click Help|Register and enter your user name and your serial number in the registration box .  Your user name must be the same, letter for letter,  as the one with which your serial number was obtained.  Check your user name and punctuation, such as points after initials, and embedded spaces, if the supplied registration number does not work.

People Index is supplied as is without warranties or guarantees of any sort and excludes any liability on the part of the copyright owner or any shareware distributor or BBS.

If you like People Index you may also like IcoFloat by Michael Cowan - a powerful button launcher and Program Manager replacement available on Compuserve as IFLOAT1.ZIP

This Help file was written using Stefan Olson's Help Writers Assistant for Windows.

I am grateful to contributors to UseNet's comp.lang.basic.visual, FidoNet's Basic_Visual, and Texas T & M University's VB List for helpful ideas about VB coding.


Overview

Click on the graphic for help on features

People Index  is a database of names, addresses, phone numbers and other personal data.  Each field is stored as text but if you are consistent about how you enter data in the same field on each record, the information can be searched as numbers or dates.

There are three tabbed cards for each record which in the sample presidents database are marked Official, Private and Notes.  The two fields for Last Name and First Name, along with the Jotter area, are common to each tab, but the rest of the information on the Official and Private cards can be different;  and the third card is for unstructured notes that you can search.

Using the Group menu and the search facilities you can create a group of records which have data in common.  For example, in the presidents database you can create a list of all presidents from New York (7), or with more than three children (19), or both (4).  Using these functions on your own data in your own database you could see all the people who have a birthday in November, or get a list of people who bought a Ford from you in 1993.

Once you have the group you want you can generate a file with all the names and address suitable for printing or importing into a spreadsheet.  You can copy a group of records to another database.

You can change the labels on the tabs, and on the field captions, in Set up so you can have names of your own choosing and in a language other than English.  You can have different field names for each database, and the menus use your field names.

This version of People Index is for single users only.

see also

Presidents  sample database


Presidents

sample database

This is a run through the presidents sample database.  The facts are the best I could find given that there is sometimes disagreement between authorities.   If you don't like my facts, feel free to change your copy:  this is purely to demonstrate how to use People Index.

You can make groups of records, such as of all Republican presidents, and sub-groups, such as Republicans from New York.  Whenever you have selected a group or sub group and you want to start over, just click All at the top right.  Or, if you have one or more sub-groups,  you can click Group|Back up.

Expressions like Official: Group|Home State mean go to the tab marked Official in this database, click on the menu Group and then click on the menu item Home State, and so on.  It is assumed that after a complete search you will press All, or Group|All,  to start over.

Republicans:   Official: Group|Party and pick Republican (17).  Republicans from New York: continue with Group| Home State and pick New York (3).

From Southern states:  Official: Group|Home State, hold down the control key and pick off the Southern states from the index then Find (13)

The 9th President:   Offcial: Group|Office and select 9th President from the index (William Henry Harrison).

Presidents who have served non-consecutive terms:  Official: Group|Office, Find, enter *&* (that's star ampersand star) in the search box below the status bar and press ENTER (the large key on your keyboard sometimes called RETURN) or Find again (Grover Cleveland)

Presidents who had no Vice President:   Official: Group|VP, Find and in the search box  enter IS NULL and click Find  or press ENTER (4)

Charles Curtis vice president: Official: Group|VP and pick Curtis, Charles from the index (Herbert Hoover)

Died in office:  Notes: click [image] and in the search box enter died in office and press ENTER or Find (8).   Those who were assassinated:  continue by double clicking the word assassinated in any of the records shown, or click [image] again and type assassinated in the search box and press ENTER (4).

Incumbent Presidents defeated when seeking re-election:  Notes:  search for defeated or if the word is visible double click it without pressing [image] first, or even if you already have (10).

College educated:  Private: Group|College, Find enter IS NOT NULL, Find (33)

Went to Harvard: Private: Group|College and then either hold down the control key and click the entries with Harvard, and press Find;  or Find and enter *Harvard* in the search box (note the star on either side of Harvard:  you need wild cards when searching for partial values in a field other than Notes) and click Find again (6).

No First Lady:  Private: Group|First Lady, Find enter IS NULL, Find (James Buchanan).

Born in the 20th century:  Private: Group|Born, Find and enter >=#January 1, 1900# press Find (8)  Note that any normal date expression will do, and dates must be embedded in pound (#) signs.  See also Dates.

Died in the 19th century:  Private: Group|Died, Find enter between #January 1, 1800# and #December 31, 1899# then click Find (20).

Died on 4th July:  Private: Group|Died, and pick them off the list using the control key, or  Find enter July 4*, Find (3).  The date search method won't work as the database requires complete dates.

Still living:  Private: Group|Died, Find and enter IS NULL, Find (5).

More than 2.2 children:  Private: Group|Children, Find enter >2.2, Find (26), of which Republicans:  continue Official: Group|Party pick Republican (11), or alternatively Whig: Group|Back up, Group|Party pick Whig (3)  Note that the decimal separator must always be a point not a comma regardless of your international setting.

No children:  Private: Group|Children, Find, enter IS NULL in the search box followed by Find  (6)

At least 3 and not more than 7 children:  Private: Group|Children, Find and in the search box type between 3 and 7 then press ENTER or click Find (23)

Average number of children:  Private: Group|Children, Find enter STATS: (note the colon), Find  (4.29 for those who had children, 3.66 for all presidents)  See also Using Find

Which president first installed a telephone in the White House: Notes [image] enter telephone and press Find (Rutherford Hayes)

Which president first installed public electronic mail in the White House: Notes [image] enter public electronic mail and press Find (Bill Clinton)

Presidents who were lawyers:   Notes, select John Adams and double click on the word Lawyer, or with any record visible click on [image] and type in the search box when it appears Lawyer then press Find (26)

In the Notes field the following are some of the words and phrases you might want to search on:

VP	former Vice President

defeated	defeated when seeking re-election

lost	lost when not incumbent

died in office	died whilst still President

succeeded:	became President by succession (note colon)

Secretary of State	former Secretary of State

(there is a space after 'State' and no colon)

House:	former Congressman

Senate:	former US Senator

Military	main career in the armed forces

Governor	had been a State Governor

survived	lived for more than 20 years after leaving Presidency

zero year	elected or reelected in a year ending with zero

Inaugural	first inaugural speech included

Also included are Washington's farewell speech, the Declaration of Independence (under Jefferson), Lincoln's Gettysburg Address, Kennedy's Berlin speech, and the articles of impeachment of Nixon.

Sources:

Margaret Bassett: Profiles and Portraits of American Presidents

Thomas Connelly and Michael Senecal: Almanac of American Presidents

Colliers Encyclopaedia

Cleveland Freenet

Groliers Encyclopaedia Americana and CIS Academic Encyclopaedia

Keesings Contemporary Archives

The London Times

Project Gutenberg

Overview


Set Up

Click on the graphic for help on features

Field captions  Type in the caption you want used for each field.  The left column is for the first tab (Official in the presidents database) and the right column is for the second tab (Private).  Where there is no separate box in the right column, the field uses the same caption as the first tab.  The maximum number of characters, including spaces, is 12 but check that your choice looks OK.  In the right column, if you leave either of the two top boxes empty the corresponding field will not appear when you switch to the second tab.  There is a default set of field captions when you create a new database.

Check the small boxes if you want the field to the left to be part of an address sequence.  The box shows an X when checked, else blank.  These values, and the field captions, can be different for each database.

The address sequence is

First name followed by  Last name

upper right field (below First Name) if checked

upper left field (below Last Name) if checked

Address field

City followed by  Post/zip code

State/county field (Home State) if checked

Country field (Party) if checked

New record defaults  Enter here any default values you want shown when you create a new record.  You can still change them individually on a new record.  These values can be different for each database.

Delete records without confirmation   Check if you want to be able to delete single records without being asked for confirmation when you press the delete button.  This value is the same for all databases.

Load database using A - Z   Check if you want the index to list only records beginning with A (or the first letter of the alphabet for which there is a record) when you load a database.  This may speed up loading of large databases.  This value can be different for each database.

List empty fields   When you list a record or a group, empty fields, and their field name, are omitted unless you check List empty fields.  This value is the same for all databases.  Even when checked, an empty field will be omitted if the field name is also blank.

Start up database   When you have loaded the database you want to use when People Index is run, click on this box to make it the start up.  The path and name will be automatically entered and saved in PEOPLE.INI

Tab captions   Type in the captions you want to use on the tabs.  These can be different for each database.  There is a default set for new databases.

Modems   If you have a modem and you want to use People Index's phone dialling facility, you can use the following entries:

Phone access PIN   Some long distance suppliers, such as Mercury in the UK, require a personal access number to be dialled before the number you want to call.  Type the access number in here.  A series of + signs will appear and the number will be encrypted in PEOPLE.INI.  When you want the access number to be dialled enter a + sign in the phone number field, or in the dial number box.  People Index will substitute the access number.  In the USA you could enter a 10XXX number instead.

Comm port   Enter the number of the comm port to which your modem is attached.  Values accepted are 1 through 9, or 0 for no modem.  People Index will accept entries other than 0 only if it can find a modem on the port number.  If you have an external modem connect it before you enter the comm port number here.  People Index does not check again except when actually dialling out.  If you have problems, edit PEOPLE.INI and in the [PEOPLE] section add an entry CommPort=2 or whatever number is appropriate.

Auto re-dial time   Enter the number of seconds (1 - 999) People Index should wait before attempting to redial a number recognised by your modem as BUSY.  Numbers will be redialled only if the re-dial lamp was clicked on when the number was dialled.

Install

Performance

Problems


Install

You may find that the best arrangement is to create a directory called C:\PEOPLE and store People Index's executable files and databases there, and keep VB300.DLL and the database engine files in your \WINDOWS\SYSTEM directory.  The following is a list of files and where to keep them:

in C:\PEOPLE

PEOPLE.EXE	main executable

PEOPLE.HLP	help file

PEOPLE.INI	ini file - must be in same directory as PEOPLE.EXE

PRESDNTS.PDB	Presidents database

in C:\WINDOWS\SYSTEM

VBRUN300.DLL	VB runtime dll

VBDB300.DLL	VB data control dll

MSAES110.DLL	Access dll

MSAJT110.DLL	Access Jet engine

If the supplied PEOPLE.INI is not in the startup directory, or if it does not point to a valid database, such as PRESDNTS.PDB, People Index will report that it cannot find the startup databasee:  click OK and the database menu will drop down.  Click on New, provide a name, and after the database has been created, switch to it and add records.

Set Up

Performance

Problems


Performance

People Index uses an Access 1.1 database with the Microsoft Jet engine.  The database has an internal counter, in conjunction with the Last Name field, to distinguish one record from another.  The internal counter is set to zero when a database is created using Database|New and is incremented by one each time a new record is added.  It is not decremented when a record is deleted.  The maximum number of records that a database can hold, including any that have been deleted and purged, is limited to the maximum value of the counter of 4,294,967,296 records which seems impracticably large.

The maximum number of records that can be listed in the index depends on the total number of characters in the Last/First name fields, but roughly speaking it is of the order of 3,000 give or take a few hundred.

If a database has more records than can be listed in the index the last item is more....  When more.... is selected People Index loads into the index the next batch of records starting from where it left off.  However large the database you can eventually get to any record through the index.  With large databases it may be more efficient to use the A - Z tabs.

Even with a limit of 3,000 or so records the time taken to load the index may be appreciable for larger numbers or slower machines.  Tests on a 486DX/33 with 4mb memory running under vfat in Windows for Workgroups showed that loading 1,000 records from within People Index took about 7 seconds and re-loading from a group took about 5 seconds. Copying 1,000 records to another database took about 25 seconds.  These times are acceptable.

For 2,000 and 3,000 loading times increased, but less than proportionately.  At over 4,000 records there is sometimes delay simply moving from one record to the next.  This is probably due to memory constraints.  With only a handful of records, such as the presidents database, People Index takes about 10 seconds to start up.

People Index will be optimal at up to a thousand records or thereabouts.  If you have many more, splitting your records into two or more databases of around 1,000 using Group|Transfer will give better efficiency.  You can still create a combined database to do an interesting large sort.

Notes   The maximum number of characters that can be stored in the Notes field is about 32,000.

Set Up

Install

Problems


Problems

Index   The index is automatically sorted 'alphabetically' with the unwanted result that numbers are often out of numerical order:  for example 2 comes before 17 and 27 comes before 143, and so on.  Similarly, dates are not helpfully ordered.

Notes   The maximum number of characters that can be stored in the Notes field is about 32,000.

Access 2   People Index databases are in Access 1.1 format.  If you have Access 2 and you have installed the Visual Basic Access 2 compatibility layer your version of VBDB300.DLL (the database control)  may change the format of packed databases to the incompatible Access 2 format.

The version of VBDB300.DLL required in your \WINDOWS\SYSTEM directory for Pack to work correctly is version 03.00.0528 dataed 28 April 1993 and is 95,200 bytes.

If you have the later version then do not use Pack.  Create a new database, using Database|New, with a name like TEMP.  Make sure that the status bar for your current database (the one you want to pack) shows All Records,  click Group|Copy to and when the database list  opens click Temp.  This will copy all your undeleted records to Temp.  Switch to Temp to check that all is OK.  If so, you can close People Index and use File Manager to delete the current database eg MYDATA.PDB, or rename it MYDATA.OLD, and then rename TEMP.PDB as MYDATA.PDB.

Apart from this problem, the later version of VBDB300.DLL is so far reported to be satisfactory.

Set Up

Install

Performance


Databases

The Database menu allows you to create new databases, to switch to a different database in the same directory, to search other directories for People Index databases, and to pack and repair databases.

For help on these functions see:

Creating a new database

Selecting a database

Packing a database

Repairing a database

Noticeboard


Creating a new database

New	Creates a new database in the current directory with a name specified by you in the box that appears.  The extension .PDB is added automatically:  People Index will not recognise anything else.  When created you will get a message that the new database has been added to the current list on the Database menu.

A new database contains no records.  The field names and tab captions are a default set, but you can switch to your new database and change them.  You will need to set the address sequences (three checked), the new record defaults (all blank), and whether to use A - Z  when the database is loaded (unchecked) -  all in Set up.

As soon as the new database is created you can copy or transfer records to it without switching to it first.

If for any reason you have no database at all, run People Index and you will get a 'can't find database' message:  press OK and the database menu will drop down.  Click on New, provide a name, and after the database has been created, switch to it and add records.

Databases

Selecting a database

Packing a database

Repairing a database

Noticeboard


Selecting a database

People Index databases in the current directory are listed on the Database menu.  To open another listed database in place of the current one, click Database and click the name of the database you want to open.

To open databases not listed on the menu itself, click Database|Directory and use the drive and directory boxes to navigate to other directories.  When you click on another directory People Index databases, if any, are listed in the files box.  Click on the one you want.

Databases

Creating a new database

Packing a database

Repairing a database

Noticeboard


Packing a database

Pack	Packing improves the performance of the database.  Over time, if you keep deleting and adding records the database will get very large and probably sluggish.  You should periodically use Pack which removes deleted files from the current database and compacts it so that it will run faster: click Database|Pack.  After packing the old database is renamed with the extension .OLD and should be deleted using File Manager.  It is kept on your disk by the packing sequence on the off chance that the packed database is somehow corrupt.  In that case delete the packed database (same name but with extension .PDB) and rename *.OLD to *.PDB where * is the name you were using.  Try packing it again.

 If you have Access 2 and you have installed the compatibility layer, see  Problems.

Databases

Creating a new database

Selecting a database

Repairing a database

Noticeboard


Repairing a database

Repair	  If your database will not load it may have been corrupted, for example, by switching your computer off without first using the Quit button to exit People Index.

Switch to another database and then click Database|Repair and pick the problem database.  If the problem is with your start up database, when you get a 'can't find database' message press OK and pick another database from the menu and then Repair the problem one.

If you haven't got another database,click on New, provide a name, and after the database has been created, switch to it and add records or Repair the problem database.

Databases

Creating a new database

Selecting a database

Packing a database

Noticeboard


Noticeboard

The noticeboard is in the lower right area under the tab cards.  You can write up to 100 characters of text here which will be saved and displayed with the database irrespective of the current record.  To enter or change text, click on the area and type in or delete whatever you want.  To make the changes permanent, click on any tab or any field before you Quit.

Databases

Creating a new database

Selecting a database

Packing a database

Repairing a database


Records

Notes   The maximum number of characters that can be stored in the Notes field is about 32,000.

Adding records

Changing records

Deleting records

Copying and moving records

Jotter


Adding records

Adding records   Press the button marked New: the status box shows New record.  If you have set default values in Set Up, they will be loaded.   As a minimum enter a name in the Last Name field.  Enter any other information for the current tab and press Save.  The new record will be added to the database and will be highlighted in the index provided it belongs to the current group.   You can then move to either of the other tabs and change the record by adding and saving further information.  You cannot move away from the current tab or record without first saving the new record or abandoning it.

You can add new records even when a group or sub-group is selected to which the new record will not belong.  When you Save it will not be displayed in the list with the current group.

Address   If you have saved an address on one tab you can switch to the other and click the caption address:  you will be asked whether you want to copy the same address: click OK if you do, else Cancel.

Field values   For search purposes it is important that if a field is intended to have the same value as an existing record, for example, if you want to add another Democratic president, the value entered must be identical else it won't be treated as the same when you search.  When you add a new record or change an existing one the Group menu changes to Select.  Click on it and the pick the field into which you want to enter a value already in the database.  A list of all values for that field is displayed.  Click on the one you want, and it is entered automatically.

If the field you pick is the one immediately under Last Name then the value for that field is entered plus the values in any fields part of the address sequence, plus the phone field, for the first record in the database which has the same value in the field.  The idea behind this, which does not apply to the Presidents database, is that this field should be used for the name of a company or organisation.  When you add a new person for the same company the rest of the address fields can be entered automatically.

Undo   You can abandon a new record before saving it to the database by clicking the button marked  Undo.  You will be asked to confirm your decision.

Records

Changing records

Deleting records

Copying and moving records

Jotter


Changing records

Changing records   Click on the field you want to change and modify the entry.  The status box shows Data change.   To save changes click the button marked Save.  You cannot move away from the current tab or record without saving or abandoning changes.

Undo   You can abandon changes before saving them to the database by clicking the button marked  Undo.

Address   If you have saved an address on one tab you can switch to the other and click the caption address:  you will be asked whether you want to copy the same address: click OK if you do, else Cancel

Field values   For search purposes it is important that if a field is intended to have the same value as an existing record, for example, if you want to add another Democratic president, the value entered must be identical else it won't be treated as the same when you search.  When you add a new record or change an existing one the Group menu changes to Select.  Click on it and the pick the field into which you want to enter a value already in the database.  A list of all values for that field is displayed.  Click on the one you want, and it is entered automatically.  Do the same for other fields.

If the field you pick is the one immediately under Last Name then the value for that field is entered plus the values in any fields part of the address sequence, plus the phone field, for the first record in the database which has the same value in the field.  The idea behind this, which does not apply to the Presidents database, is that this field should be used for the name of a company or organisation.  When you add a new person for the same company the rest of the address fields can be entered automatically.

Records

Adding records

Deleting records

Copying and moving records

Jotter


Deleting records

Deleting records   Select the record you want to delete and when it is displayed click the button marked Delete.  You will be asked to confirm unless you have checked Delete records without confirmation in Set up.   You can delete all the records in the current group or sub-group with Group|Delete.  You will be asked to confirm regardless of the confirmation setting in Set up.   You cannot use Group|Delete to delete all records in a database:  you should use File Manager to delete the *.PDB INSTEAD.

Deleted records are gone for good.  As an alternative you may find it safer to create a database called, say, DELETED.  Instead of using Delete transfer the records singly or in groups to DELETED.   If you want to recover a record you can switch to DELETED and transfer it back.

Records

Adding records

Changing records

Copying and moving records

Jotter


Copying and moving records

All records in the current database, or the current group or sub-group, can be Copied to or Transferred to another database.  These operations work only on the current group, or if no group is selected then on all records in the database.

Copy   To copy the current group of records, or all records, to another database click Group|Copy to and select the destination database from the directory box that appears.  A horizontal percentage meter shows progress.  To copy only the current record to another database use Record|Copy to.  These operations leave the selected records in the current database.

Transfer   To transfer the current group of records, or all records, to another database click Group|Transfer and select the destination database from the directory box that appears.  A horizontal percentage meter shows progress.  To transfer only the current record use Record|Transfer

Transfer deletes the selected records from the current database without confirmation.

Records

Adding records

Changing records

Deleting records

Jotter


Jotter

  The area to the right of the address field.  You can type in up to 100 characters of text which will be saved and displayed when the record is current on both the first and second tabs.

Records

Adding records

Changing records

Deleting records

Copying and moving records


Groups

   A key function of People Index is the ability to create groups and sub-groups of records.  For example, you may wish to see a list of Republican presidents, or even of Republican presidents whose home state is New York. Once you have created a group you can obtain information only about that group.  To make a Group click on the Group menu and then on the menu item representing the field which contains values you want to use.  The index will show a list of all the values in the selected field with each value included only once, and the status bar will show the field name and the number of different values displayed.  Blank (empty) values are not shown:  see Is Null.   Click on the value you want, say Republican, and the index will show a list by Last Name, First Name of all records which have Republican in that field.  The match is exact:  Democratic Republican will not be included.  For partial matches see Find.  When you make a Group the status box will show 'Grouped records' and below the status box will be shown the value used to create the Group:  eg 'Republican'.     To the right of the status box the left-hand counter will show the number of records in the group, and the right-hand counter will continue to show the number of records in the database.  If you click on the Group menu again you will see that the name of the field used is ticked.

 Sub Groups   When you have created a Group you can make a sub-Group from the same records by repeating the process.  If you want you can switch to another tab.   To list Republican presidents from New York make a Republican group as before then click again on the Group menu and select Home State.  From the list of states pick New York.   You will be shown a list of presidents who satisfy these criteria.   Below the status box you will see 'New York & Republican'.

Now pick Served from the Group menu.  You will see three items showing the years of office of the three presidents currently in the Group:  pick 1953 - 61 and you will be down to just one: Eisenhower.   The criteria statement shows '1953 - 61 & New York & Republican.

 Below the status box, Multiple values from the same field are separated by commas.  Read the commas as OR meaning that a record is included if it has one of these values in the appropriate field.  Values from different fields are separated by & meaning that a record is included only if it has the chosen values from each of the selected fields.

Back up   Suppose we want to go back a step to the three New Yorkers:  clicking Group|Back up will take you there.   The status area now shows again 'New York, Republican'. You can back up until you are back to the first Group.  To return to all records click Group|All or  All on the A-Z tabs.

A - Z Groups

Using Find

Searching Notes

Dates


A - Z Groups

You can click on a letter of the alphabet and see a list of all records whose Last Name initial letter is the same.

Selecting an A - Z  group cancels any previous group;  but you can go on to create sub-groups from the initial letter using the other fields:  for example, presidents whose name begins with H and who came from Ohio.

Using Find

Searching Notes

Dates


Using Find

A wider range of groups can be created using the Find key.

Multiple values   You can create a group by selecting multiple values from the index:  for example, using the presidents database, click menu Group | Party, hold down the control key,  and from the index click Democratic Republican and Federalist.  Then click Find: you will be shown a list of the first six presidents.  Confirm this by clicking Group | Office:  the list shows the values in the Office field for this group as 1st President.....6th President.  Press Cancel to go no further.  Note that when you make a group by selecting multiple values the values you pick are listed below the status box.  If you pick many they may not all find room to show.  Values from the same field are separated by commas.  Read the commas as OR meaning that a record is included if it has one of these values in the appropriate field.  Values from different fields are separated by & meaning that a record is included only if it has the chosen values from each of the selected fields.

Partial values   You can make a group by specifying a partial value for a field.  Click menu Group and select the field you want.  When the list of complete values is shown click Find.   A text box appears under the status bar in which you can enter the partial value using the wild cards * and ?.    Then press Find again.

For example, to find all presidents who took office in the 19th century use Group | Served, press Find and enter 18* which searches for all entries which begin with 18.  22 presidents are listed.  To find all who left office in the 20th century use *-19??  This searches for entries which contain 19 immediately preceded by a dash and followed by any two characters.  17 are listed including William McKinley who took office in 1897 but ceased in September 1901 when he was assassinated, and excluding Bill Clinton for whom no final date is shown (and who could serve until 2001).

Partial matching depends on a knowledge of how the entries have been made.  In the last example there was no record where there was a space between the dash and the number 19:  if there had been it would have been omitted.  You will have more success with partial matches if you are systematic when making entries.

Using partial matches you could search the zip/post code field for all addresses in a zone;  or the phone field for all numbers with a particular area code.

Upper and lower case, A and a, are treated as the same.

The wild cards are interpreted as follows:

X*	begins with X or x followed by any text or none

X * 	begins with X or x followed by a space and any other text or none

*X* 	contains X or x within any other text or none

*X 	ends with X or x preceded by any other text or none

? 	any character in the place marked (excluding none)

*19??	ends with 19 followed by any two characters

*19??*	includes 19 followed by at least two characters

? 	consists of a single character

?? 	consists of exactly two characters

Spaces are treated as characters unless at the very beginning or the very end in which case they are ignored.

Special keys      Used for making searches for dates, number comparisons or (with care) text comparisons.

A search may begin with one or more of the comparison operators <, >, and =

< 	less than what follows

<= 	less than or equal to what follows

= 	exactly equal to what follows

>= 	greater than or equal to what follows

> 	greater than what follows

<> 	not equal to what follows

In addition you can use the special sequence between......and...... where the dots are replaced by numbers or dates, or not between......and........  For example, between 3 and 10 would find all values in the range 3 to 10 including both ends, and not between 3 and 10 would find all numbers outside of the range 3 to 10.

Numbers  To find all presidents with fewer than 3 children click Group | Children, Find and enter <3   To find those with exactly 4 children use =4, those with at least 5 and not more than 9 use between 5 and 9.

When entering numbers in a record use only digits and a decimal point if needed.  For example, use 12535.32 not $12,535.32  The decimal separator must always be a point, not a comma.  You may disregard this advice perfectly safely but the special search keys may not work.

You can use the comparison operators with text, but with care about what they mean.  To list all presidents from states the initial letter of which is in the range M to Z use Group|Home State, Find and enter >"M".  All states beginning with M or later are included.  >"Mi" excludes Massachusetts, but  includes Michigan.  Trial runs will be a good idea.  You can easily check what is included after making any Find search by reselecting the same field again to see what is listed in the index as values.

Dates  see Dates

Special operators  You can use IS NULL and IS NOT NULL to find records with a field that is empty or non-empty.  For example to find presidents who had no children use Group|Children, Find and enter IS NULL.   To find a list of all ex-presidents who have died use Group|Died, Find and enter IS NOT NULL.

STATS:  For fields that contain only valid numbers you can enter in the search box STATS: and press ENTER or Find.   The status box will says Stats for <field name> and underneath something like (using Children and all records)

Count 35   Total: 135   Avg: 4.26 (3.63)

Max: 15    Min: 1

STATS: ignores empty fields so compare the value for Count with the number shown either for the current group, if there is one, or for all records (41 in this case).  The difference is records in which the field is empty.  The first figure for average is for records included in Count (those with a value in the field).  The figure in brackets is the average if Total is divided by the number of records in the group including those with no value in the field.  Count includes non-numeric fields and treats them as zero unless the first character is itself a number.

To exit a STATS: operation press CANCEL.

Invalid search   Your search may fail with an invalid search message.  This will happen if either the entry in the search box does not conform to the specifications above;  or, one of the records contains an inconsistent entry in the field you are using for your search.  For example, if you are trying to get a list of presidents with more than four children and any record in the Children field contains a word instead of a digit, eg 'three' instead of '3'.  You could get an invalid search when searching for dates if a record has a date in the 'wrong' short date format eg 19/8/46 when it should be in the US 8/19/46.  This points up the importance of entering data consistently and carefully, especially with numbers and dates, so that searching can be done successfully.

Groups

A - Z Groups

Searching Notes

Dates


Searching Notes

The Notes field on the third tab can be searched for text.  People index will list all records with matching text.  The records found form a group or sub-group.

For example, if you have created a group consisting of Republican presidents you can then find the sub-group which has the word defeated in the Notes field.

If you can see the word or phrase you want to search for in the current record, highlight it by dragging the mouse over the words with the left button held down so that it is in reverse video, then click the Search button [image]   If you want to search for a single word, just double click on the word with the left mouse button and the search will begin immediately.

If you can't see the word or phrase you want, click on the search button [image] enter the text in the search box and press Find or [image] again.

After a search, the first occurence of the words searched for are highlighted in the Notes field of each record found: later occurences in the same record are not highlighted.

Having made one successful search you can go on and make further searches using words in the Notes field, or fields on either of the other tabs using the Group menu.

You can use Group|Back up to reverse the effect of the last search.

Groups

A - Z Groups

Using Find

Dates


Dates

The way you enter dates in records and the formats you can use when searching for dates, can be affected by Windows international settings.  This is particularly the case with short dates such as 8/10/94.  With a US setting this is August 10, 1994.  With most European settings including the UK, Australia and New Zealand, and English speaking Canada, it is 8 October 1994.  Some countries, including French speaking Canada, put the year first such as 94/10/8 for 8 October 1994.  There are other possibilities.  Windows, and People Index, recognise only the short form you have selected in Windows international setting.

Windows (and hence People Index) always recognises dates in the form October 10, 1994.  Many other formats are recognised, such as abbreviated versions, for example, Oct 10, 94 but you should test first before entering lots of dates in records.  If only two digits are given for the year they will be read as the current century.

When changing your International settings in Control Panel, it may not be enough merely to enter your country in the first international screen.  You should also click Change in the date section to get the second screen to make sure the options there are what you want.

Entering dates in records   Use a format recognised by your current Windows setting, or the always recognised long format October 10, 1994, but do NOT include # signs.

Searching for dates with Find

Dates can be searched but the date expression must be embedded between # symbols, for example, #February 7, 1994#   Expressions such as #11/6/94# are interpreted according to your Windows international settings: as November 6, 1994 in the US and as 11 June 1994 in the UK.  The #10/5/23# form, with a two digit year, is for dates in the present century.  You can use a four digit year for other centuries, eg #10/5/1826#.

A date search may begin with one or more of the comparison operators <, >, and =

< 	earlier than the date

<= 	before or on the date

= 	the exact date

>= 	on or after the date

> 	after the date

<> 	not on the date

In addition you can use the special sequence between......and...... where the dots are replaced by numbers or dates, or not between......and........  For example, between #March 1, 1992# and #December 12, 1993#  would find all values in the range including both dates, and not between #March 1, 1992# and #December 12, 1993# would find all dates outside of the range, before and after.

For example, switch to the second (Private) tab and search for all presidents born in the 18th century.   Click Group|Born followed by Find and enter <=#December 31, 1799# and press ENTER or Find.   You will be shown a list of 13 presidents.  To find all presidents who died in the present century click Group|Died followed by Find and enter >=#1 Jan 1900# and press ENTER.  To find all presidents born in the 19th century use Between #Jan 1, 1800# and #Dec 31, 1899#

Partial dates must be searched as text without # signs.  To find all presidents who were born on July 4 in any year search Born for July 4 * (one so far)  Maybe it is just as easy in this case to pick the date off the list in the index.

Groups

A - Z Groups

Using Find

Searching Notes


Extracting data

Information in the database can be written out to a file using the Record or Group menus. With Record. the information written out relates to the current record.  With Group, the information relates to the current group or sub-group, or if none, then to the whole database.

Addresses

Listing records

Exporting records to spreadsheets


Addresses

Address data extracted is only from the current tab and address sequence as defined in Set up.

The address sequence is

First name Last name

upper right field (Office in the presidents database) if checked in set up

upper left field (VP) if checked in set up

Address field

City Post/zip code

State/county field (Home State) if checked in set up

Country field (Party) if checked in set up

Current tab refers to tabs below the record data: Official or Private in presidents database.

When you click on Record|Address the address sequence from the current record and tab is copied to the clipboard from where it can then be pasted into any other document using the standard Windows Edit|Paste commands.  Even if there is nothing in the Address field, whatever is in the other fields in the sequence is copied.  The same action is performed when you left click on the envelope icon.

Group|Address creates a file with the same root name as the current database plus an extension .A01, .A02.... etc up to .A00 containing the address sequence for each record in the current group and from the current tab excluding any that have the Address field itself blank.  The numbering of the file extensions is reset to .A01 each time a database is loaded, or after .A00.  The same action is performed when you right click on the envelope icon.

Extracting data

Listing records

Exporting records to spreadsheets


Listing records

When you click on Record|List all the data for the current record is copied to the clipboard from where it can be pasted into a document using the standard Windows Edit|Paste commands.  In addition a file is created of the same information with the root name of the current database and with an extension of .R01, .R02.....R00   The numbering of the file extensions is reset to .R01 each time a database is loaded, or after .R00.

For example if you pick the record for Bill Clinton and then click on Record|List you will find the following information in PRESDNTS.R01 (or another number in the sequence) and on the clipboard:

William Jefferson Clinton

Official

Office: 42nd President

VP: Gore, Al

Address:

The White House

1600 Pennsylvania Avenue

City: Washington DC

Zip: 20501

Home State: Arkansas

Party: Democratic

Served: 1993-

Phone: (202) 246 1414

Private

College: Georgetown U, Oxford & Yale

First Lady: Hillary

Address:

City:

Zip:

Born: August 19, 1946

Died:

Children: 1

Phone:

Jotter:

Current President   Due for re-election in 1996

Notes:

Rhodes Scholar and Honorary Doctor of Civil Law, Oxford University.

First President to have public electronic mail in the White House.

Born: Hope, Ark.

Married: Oct. 11, 1975 Hillary Rodham

Religion: Baptist

Profession: Lawyer

E-mail: president@whitehouse.gov

Governor of Arkansas 1979-81 and 1983-93

Cabinet

Secretary of State: Warren Christopher.

Secretary of the Treasury: Lloyd Bentsen.

Secretary of Defense: William Perry.

Attorney General: Janet Reno.

Secretary of the Interior: Bruce Babbitt.

Secretary of Agriculture: Mike Espy.

Secretary of Comerce: Ronald Brown.

Secretary of Labor: Robert Reich.

Secretary of Health and Human Services: Donna Shalala.

Secretary of Housing and Urban Development: Henry Cisneros.

Secretary of Transportation:  Federico Pena.

Secretary of Energy:  Hazel O'Leary.

Secretary of Education:  Richard Riley.

Secretary of Veterans Affairs:  Jesse Brown.

Bill Clinton's Inaugural Address

My fellow citizens, today we celebrate the mystery of American renewal. This ceremony is held in the depth of winter, but by the words we speak and the faces we show the world, we force the spring.  A spring reborn.....[rest omitted here]

Group|List creates a file containing all information from all records in the current group or sub-group, or all records in the database if no group is currently selected, formatted in the same way, but with a line after each record, and the list is in alphabetical order of Last Name. The files have the same root name as the current database plus an extension of .L01, L02....L00   The numbering of the file extensions is reset to .L01  each time People Index starts up or when a different database is selected, or after .L00.   A horizontal percentage meter reports progress.

Blank fields are listed only if the field name is not blank as well  and List empty fields is checked in Set Up.   Jotter and Notes are never listed if empty.

Extracting data

Addresses

Exporting records to spreadsheets


Exporting records to spreadsheets

To export data for the current group use Group|Export.   All the data for the currently selected group or sub-group of records, or if none is selected then for the whole database, will be written to a file in a comma delimited format suitable for importing into Excel, Lotus or Quattro Pro spreadsheets.   Files have the same root name as the current database plus an extension of .X01, X02....X00   The numbering of the file extensions is reset to .X01 each time a database is loaded, or after .X00.  A horizontal percentage meter reports progress.

The first line of the file contains the column headings as entered for the field names in Set up.  Each separate line from the Address field is delimited to become a separate column in the spreadsheet.  It is not practical to show a full example as WinHelp wraps the lines, but the following is part of what would be obtained for George Bush:

"First","Last name","Office","VP","Address 1","Address 2","Address 3","Address 4","City","Zip","Home State","Party","Served", etc

"George Herbert Walker","Bush","41st President","Quayle, Dan","The White House","1600 Pennsylvania Avenue","","","Washington DC","DC 20501","Texas","Republican","1989-1993", etc

and so on with the column headings, and each record, on a single line.  Consult your software manual about how to import the file to your spreadsheet.

Extracting data

Addresses

Listing records


Dialling phone numbers

click on the graphic for feature details

You will need a modem to use People Index's dialling facility.  If you have one, set the Comm Port number in Set Up.  The Phone menu, the phone icon and the re-dial lamp will appear whenever People Index is started.

Dialling out

 If there is a number in the Phone field you can dial it by left clicking the phone icon.  If there are arrows adjacent to the Phone field, indicating that it contains more than one number, click the arrows until the number you want is shown. For any other number, right click the phone icon and when the dial number box opens enter the number you want to dial using the keyboard, then click the Dial button or press ENTER.  Use a + sign to indicate that the phone access PIN (or designated 10XXX) number is to be dialled:  see also Set up.

For each of these operations you may use the Phone menu instead.

Last number re-dial   Right click the phone icon to open the dial facility and click the Last button, or press the INSERT key.  The last five different numbers are stored in a buffer which is cycled through by repeatedly clicking Last.  Click Clear or press DELETE to clear the current entry in the dial number box.

 As soon as the modem goes off-hook (equivalent to lifting the handset) the icon changes to a handset.  To put the modem back on hook ie disconnect, click the icon again.

If the number called is busy, and if your modem recognises the busy signal, the modem will go on-hook, the icon changes back to a phone, and the dial number box shows the number dialled plus the word BUSY.

 Auto re-dial   Busy numbers recognised by the modem can be automatically redialled after a number of seconds (1 to 999) as specified in Set up.  Before making a call click the re-dial lamp to switch it on.  The auto re-dial lamp flashes when counting down to a re-dial.  Click it again to turn it off.

When your call is ringing out, or when you hear it answered over your modem's speaker, pick up the handset and click the handset icon to disconnect the modem.  This does not disconnect the call.  If you do not disconnect the modem yourself the line may remain connected even after you have put the handset back on.


Index  Lists records currently available: either all records in the database, or only those which have fields that match the current group.  Click on an entry to see the record, or use the up/down arrow keys to highlight the one you want and then press ENTER.  Also used to list the values in a field when creating a group of records.


Last Name    Each record must have an entry in this field which is listed in the Index so that it can be retrieved.  The entry can be the same as any other - an internal counter keeps each record separate.  The maximum number of characters is 50.  You may change the caption against this field in Set up.


First Name   If there is an entry in this field it is listed after the Last Name field in the Index.  The maximum number of characters is 30. You may change the caption against this field in Set up.


VP/Office You may change the caption against these fields in Set up and have different captions in the first and second tabs (Official and Private).  If you leave the caption for one of these fields blank in the second tab (Private) the field will not appear when you switch to that tab.  You may also specify that the contents of either of these fields is included or not included in an address listing, separately for each tab, by checking or unchecking the adjacent check box in Set up.  The maximum number of characters is 50 in each field.


Address   This field is always included in an address listing.  The maximum number of characters is 200.  Press ENTER to insert a fresh line.  Only the first line appears in the Index when this field is searched.  You may change the caption against this field in Set up.


City   This field is always included in an address listing.  The maximum number of characters is 30.  You may change the caption against this field in Set up.


Zip   This field is always included in an address listing.  The maximum number of characters is 20.  You may change the caption against this field in Set up.


Phone   This field should only be used for phone numbers.  You may enter two or more separate numbers by pressing ENTER after each.   A pair of small up/down arrows appears to the right of the phone field when there is more than one number.  Each distinct number is shown in the index when this field is searched.  If you have a modem attached left clicking  the telephone icon dials the number currently visible in this field. The maximum number of characters is 100.  You may include formatting, such as brackets, provided your modem can cope.  You may change the caption against this field in Set up.


Home State/Party   You may change the caption against these fields in Set up and have different captions in the first and second tabs (Official and Private).   You may specify that the contents of either of these fields is included or not included in an address listing by checking or unchecking the adjacent check box in Set up.  The maximum number of characters is 30 in each field.


Served You may change the caption against this field in Set up and have different captions in the first and second tabs (Official and Private). The maximum number of characters is 30.


Jotter   Text typed in this area is saved with the record and appears on both the first and second tabs (Official and Private).  Maximum length is 100 characters.


Status   The status box shows whether all records are available or only those matching the current group;  it also provides other information and progress reporting.


Database   This field shows the file name of the current database.


Record count   These two fields show, on the right, the total number of records in the current database;  and on the left the number in the current group if any is selected.


Tabs   Click on the tab labels to move between cards.  You may change the tab names in Set up.


A to Z index    Click on a letter of the alphabet to get a list of  records with a Last Name beginning with the chosen letter;  or click on All to get all records in the database.


Control buttons    Click on New to make a new record, Delete to delete the current record, and Quit to exit the program.  The functions of New and Delete, and their captions, change with the state of the program:  for example, after you have clicked on New to make a new record, the caption changes to Undo so that you can abandon it, and Delete changes to Save so that you can save it.


Icon   If you have an active modem attached a phone icon is displayed, as shown here, else it is blank.  When the phone is displayed you can click on it to dial phone numbers.


ReDial lamp   Appears only if you have a modem attached.  Clicking on it toggles it between on and off.  When on, if you get a busy signal when you dial out, the number will be redialled automatically after the number of seconds specified in Set up.  While active and waiting to redial, the lamp flashes.


Noticeboard    Any text, up to 100 characters, you type here is saved with the database and displayed whilst it is in use.


Envelope   Left click to copy the name and address of the current record to the clipboard:  you can then paste it into a document using Edit|Paste.  Right click to create a file of the names and addresses of all records in the current group, if one is selected, or if not, of all records in the database.


Arrows   When the phone number field contains more than one number, up/down arrows appear next to it to allow scrolling between them:  click on the down arrow to move down and on the up arrow to move up.


Fields    The Group menu displays the field captions for the current tab.  Click on a field name to see the values stored in the field abstracted from all records in the current group or database.  Select from the displayed values one or more to create a group.  For example, if you click on Home State you will be shown a list of home states from which Presidents have come.  You can select one or more so that you can see a listing of presidents only from the home states you have chosen.  When you create a group in this way, the field name is marked with a tick.   To select more than one value hold down the control key when you click each value in the index:  then press the Find button.


All   Select All to list all records in the database.  Cancels any group selections.  When all records are selected All is marked with a tick.


Back up    When you have already selected a sub-group using more than one field, Back up is enabled.  Clicking Back up cancels the last sub-group selection and returns you to the previous level.   For example, if you had chosen Party|Republican followed by Home State|New York, clicking Back up will return you to the list of all Republican presidents regardless of home state.


Addresses    Creates a file in the current directory listing  names and addresses abstracted from each record in the current group, or if none is selected then from all records in the database.


List    Creates a file in the current directory listing all  information abstracted from each record in the current group, or if none is selected then from all records in the database, including both tabs and the Notes field.


Export    Creates a file in the current directory listing all information abstracted from each record in the current group, or if none is selected then from all records in the database, including both tabs and the Notes field.    The file is in comma delimited format suitable for importing to a spreadsheet.


Copy to    Copies all the records in the current group to another existing database.


Transfer    Copies all the records in the current group to another existing database, and deletes them from the current database.


Delete    Deletes all the records in the current group, or if none is selected then all in the current database, subject to confirmation by the user.


Database   Shows the name of the current database


Status    Shows that the list is currently based on a group of records not the whole database


Group count    There are 17 records in the current group


Database count    There are 41 records in the current database


Selection criterion   The current Group is based on the field value Republican.   Clicking on the Group menu would show that Party is ticked.


Group count    There are 3 records in the current group


Selection criteria   The current group is based on the field values New York and Republican.   Clicking on the Group menu would show that Party  and Home State are both ticked.


Group count    There is 1 record in the current group


Selection criteria   The current group is based on the field values 1953 - 1961 and New York and Republican.   Clicking on the Group menu would show that Party , Home State  and Served are all ticked.


A - Z     Click on a letter of the alphabet to get a list of all records in the database with a Last Name starting with that letter.   Cancels any current group selections.


All    Click on All to get a list of all records in the database.   Cancels any current group selections.


Index   Shows the dates abstracted from the Born field


FIND button    Press to execute a search of multiple values chosen from the index; or to open the search box under the status bar  and to execute the search when you have entered the search criterion.


CANCEL button   Press to cancel the Find operation


Status bar   Shows the field on which a search is to be made.


Search text   Enter the text to be used for the search.  It can include wild cards (* and ?) or special key searches.


Field captions   The captions on the left are for the first tab (Official in the presidents database), and where there is no corresponding  box on the right also for the second tab (Private).  You can enter up to 12 characters, but check that it looks OK on the tab


Last Name   You may enter up to 12 characters as the name of this field.  This field is used to list records in the index so it should be used for Last Names or something similar


Phone   You may enter up to 12 characters as the name of this field.  This field is intended for telephone numbers and has internal specialised search and display features.


Private tab captions  You may enter up to 12 characters as the name of each these fields.   The fields are immediately under Last Name and First Name in the second tab (Private in the presidents database).  If the caption is left blank the field does not appear.


Private tab captions  You may enter up to 12 characters as the name of each these fields.  The bottom one may not look right if there are 12 wide characters so check to see it looks OK.  The fields are the three on the bottom right of the second tab (Private in the presidents database)


Address sequence   Check this box if you want the field to its left to be part of an address sequence.


New record defaults   Whenever you create a new record any values you enter here are temporarily copied to the new record.  They can be individually changed at the time you make the new record.  In the example from the presidents database Washington is the default for the City field on the Official tab because all presidents since John Adams have had their official residence in Washington.  The Democratic example is less certain.


Tab captions   Enter the captions you want to appear on each tab.   You may enter up to 8 characters on each.  Check to see that they look OK


Start up database   Open the database you want People Index to use when it starts up, then click on this box.  The path and database name are entered.


A - Z start up   Check this box if you want the database to start up listing only records with Last Name beginning with A or whichever next letter of the alphabet occurs first.  This can reduce loading time for very large databases


Delete without confirm   Check this box if you want to be able to delete individual (not group) records without being asked to confirm


PIN number   If you have a modem and a PIN which must be dialled to use a trunk service, such as Mercury in the UK, enter it here.  It will be dialled at the place you put a + in the phone field.  You can use a 10XXX number instead.  PINs are encoded to hinder snoopers, but it is a simple encryption which will not defeat NSA or a keen teenager.


Comm port   If you have a modem attached enter the comm port number here (in the range 1 to 9).  People Index will not accept a comm port number if no modem can be detected.


Re-dial time   If you have a modem attached, enter the number of seconds to wait between redial attempts (1 to 999)


Auto re-dial lamp    Appears only if you have a modem attached.  Clicking on it toggles it between on and off.  When on, if you get a busy signal when you dial out, the number will be redialled automatically after the number of seconds specified in Set up.  While active and waiting to redial, the lamp flashes.


Phone number   When a number is displayed in the current records Phone field, left clicking the Phone icon opens the dialling facility and dials the number shown


Dial/Cancel button   Clicking this button when Dial is shown dials the number displayed in the dial number box, and cancels the call when Cancel is shown


Dial number box   Displays numbers to be dialled.   Numbers can be entered from the keyboard or by clicking the Last (number) button or by right clicking on the current record's Phone field


Last number button   The last five different  numbers dialled are stored in an internal buffer.  Clicking Last cycles through them displaying each in the dial number box.  When the number you want is displayed it can be dialled by clicking the Dial button


Clear button    Click Clear to delete the number currently displayed in the dial number box


Phone icon   Left click the Phone icon to dial the number shown in the current records Phone field.  Right click to open the dial facility.  Clicking the Phone icon when the dial facility is open closes it.  When a number is being dialled, and while the modem remains off hook, the phone icon is replaced with a handset icon which can be clicked to cancel dialling and put the modem on hook.  Putting the modem on hook does not break a connection if you have lifted your phone handset.


List empty fields   Check if you want all field names to be shown in Lists, including any fields that are empty (see Listing records).


List    Creates a file listing all  information abstracted from the current record


Address   Copies the name and address from the current record to the clipboard for use in other documents


Copy to   Copies the current record to another database


Transfer  Moves the current record to another database and deletes it from the current database